package io.renren.modules.shop.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import io.renren.modules.shop.entity.CustomerMerchantVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;


@Mapper
public interface CusMerchantDao extends BaseMapper<CustomerMerchantVO> {
    @Select("select shop_customer.login_name,shop_customer.mobile_phone from shop_customer left join shop_merchant on shop_customer.mobile_phone = shop_merchant.mobile_phone where shop_merchant.mobile_phone = #{phone}")
    CustomerMerchantVO getBy(Long phone);
}
